<?php
/**
 * Copyright (c) 2010, Slawomir Mazur <mazursllawek@gmail.com>
 * 
 * All rights reserved.
 * 
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions 
 * are met:
 * 
 * o Redistributions of source code must retain the above copyright notice, 
 *   this list of conditions and the following disclaimer.
 * o Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation
 *   and/or other materials provided with the distribution.
 * o Neither the name of the Softisland nor the names of its contributors
 *   may be used to endorse or promote products derived from this software
 *   without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 
 * HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
/**
 * Enter description here...
 *
 * @package     System
 * @copyright   Slawomir Mazur (c) 2010 (http://www.zend.com/zce.php?c=ZEND011643)
 * @license     http://www.opensource.org/licenses/bsd-license.php
 * @author      Slawomir Mazur <mazursllawek@gmail.com>
 */

class System_Model_Library extends Zend_Db_Table_Abstract
{
	protected $_name = 'library';
	
	protected $_primary = 'library_id';
	
	/**
	 * Statuses
	 * @var int
	 */
	const UPLOADED = 1;

	const READED = 2;
	
	const ERROR = 3;
	
	const DELETED = 4;
	
	public function getLibraryById($id)
	{
		$id = (int) $id;
		$result = $this->find($id);
		
		if (!$result->count()) {
			throw new Exception('Library with the given id doesn\'t exists');
		}
		return $result->current();
	}
	
	/**
	 * Load all libraries from given company
	 * 
	 * @param $companyId company id for which history is retrive
	 * @param $value value that is searched
	 * @param $attributeId attribute id for searched value
	 * @param $year which stands for next library annotation
	 * 
	 * @return string
	 */
	public function getLibrariesHistoryByCompanyIdSQL($companyId, $value, $attributeId, $year)
	{
		$resultObject = new stdClass();
		$resultObject->rows = array();
		
		$select = $this->getAdapter()->select();
		$select->from(array('l' => 'library'), array('library_id', 'year' => 'YEAR(created_at)'))
			->where('l.company_id = ?', $companyId, Zend_Db::INT_TYPE)
			->where('l.status = ?', System_Model_Library::READED, Zend_Db::INT_TYPE)
			->order(array('l.created_at DESC'));
		
		$libraryIds = $this->getAdapter()->fetchAll($select);
		
		if (0 == count($libraryIds)) {
			return $resultObject;
		}
		
		foreach ($libraryIds as $page => &$libraryAnnotation) {
			if ($libraryAnnotation['year'] == $year) {
				$libraryAnnotation['notshow'] = true;
				break;
			}
		}		
		$resultObject->navigation = $libraryIds;
		
		/* @var $attributeModel System_Model_Attribute */
		$attributeModel = Gp_App::getModel('system/attribute');
		$mapping = $attributeModel->getAttributesMapping();
		
		// load libraries from given company
		$select = $this->getAdapter()->select();
		$select->from(array('l' => 'library'), array());
		
		// parse attributes if not empty
		$session = new Zend_Session_Namespace('navigationSession');
		$attributesToSelect = $session->attributesToSelect;
		if (!empty($attributesToSelect)) {
			// add to standard columns which are library_id and currently searched value
			$attributesToSelect[] = 'library_id';
			$attributesToSelect[] = $mapping[$attributeId]['code'];
			
			$select->joinInner(array('h' => 'history'), 'l.library_id = h.library_id', $attributesToSelect);
		} else {
			$select->joinInner(array('h' => 'history'), 'l.library_id = h.library_id', '*');
		}
		
		$select			
			->where('h.' . $mapping[$attributeId]['code'] . ' LIKE ?', $value . '%')
			->where('l.library_id = ?', $libraryIds[$page]['library_id'], Zend_Db::INT_TYPE)
			->where('l.company_id = ?', $companyId, Zend_Db::INT_TYPE)
			->where('l.status = ?', System_Model_Library::READED, Zend_Db::INT_TYPE)
			->where('YEAR(l.created_at) = ?', $year, Zend_Db::INT_TYPE)
			->order(array('l.created_at DESC', 'h.gene_id', 'h.gene_symbol'));

		$resultObject->rows = $this->getAdapter()->fetchAll($select);

		return $resultObject;
	}
	
	/**
	 * Return possible library years
	 * 
	 * @param int|bool $library_id
	 */
	public function getAnnotationYears($libraryId = false) 
	{
		$select = $this->select()
			->from($this->_name, array('DISTINCT YEAR(created_at)'))
			->where('status = ?', self::UPLOADED)
			->orWhere('status = ?', self::READED)
			->order('created_at DESC');
			
		if (false !== $libraryId) {
			$select->where('library_id = ?', $libraryId);
		}
		
		return $this->getAdapter()->fetchCol($select);
	}
	
	public function getCollectionSql()
	{
		$select = $this->select()
			->where('status = ?', self::UPLOADED)
			->orWhere('status = ?', self::READED)
			->order('created_at DESC');
				 
		return $select;
	}
	
	public function getStatuses()
	{
		return array(
			self::UPLOADED => 'Uploaded',
			self::READED => 'Readed',
			self::ERROR => 'Error',
			self::DELETED => 'Deleted'
		);
	}
}